from django.db import models

from apps.aiauth.models import Role


# class Enterprise(models.Model):
#     enterprise_id = models.BigAutoField(primary_key=True, db_column='enterprise_id')
#     username = models.CharField(db_column='username', max_length=20)
#     password = models.CharField(db_column='password', max_length=200)
#     role_id = models.ForeignKey(Role, models.DO_NOTHING, db_column='role_id')
#     gen_time = models.DateTimeField(db_column='gen_time')
#     edit_time = models.DateTimeField(db_column='edit_time')
#
#     class Meta:
#         db_table = 'statistics'
#         verbose_name = '企业表'
#
#
# class EnterpriseInfo(models.Model):
#     STATUS = (
#         ('0', '待审核'),
#         ('1', '已通过'),
#         ('2', '未通过')
#     )
#     enterprise_id = models.ForeignKey(Enterprise, models.DO_NOTHING, db_column='enterprise_id',
#                                       blank=True, null=True, related_name='statistics')
#     name = models.CharField(db_column='name', max_length=50)
#     address = models.CharField(db_column='address', max_length=200)
#     creditcode = models.CharField(db_column='creditcode', max_length=18)
#     contact = models.CharField(db_column='contact', max_length=20)
#     phone = models.CharField(db_column='phone', max_length=11)
#     introduction = models.TextField(db_column='introduction')
#     businesslicense = models.CharField(db_column='businesslicense', max_length=255)
#     status = models.IntegerField(db_column='status', default=0, choices=STATUS)
#     gen_time = models.DateTimeField(db_column='gen_time')
#     edit_time = models.DateTimeField(db_column='edit_time', blank=True, null=True)
#
#     class Meta:
#         db_table = 'enterprise_info'
#         verbose_name = '企业信息表'
#
#
# class RecruitmentInfo(models.Model):
#     recruitment_id = models.AutoField(primary_key=True, db_column='recruitment_id')
#     enterprise_id = models.ForeignKey(EnterpriseInfo, models.DO_NOTHING, db_column='enterprise_id',
#                                       blank=True, null=True, related_name='enterprise_info')
#     position = models.CharField(db_column='position', max_length=50)
#     position_type = models.CharField(db_column='position_type', max_length=20)
#
#     number = models.IntegerField(db_column='number')
#     edu = models.CharField(db_column='edu', max_length=20)
#     salary = models.FloatField(db_column='salary')
#     nature = models.CharField(db_column='nature', max_length=20)
#     work_place = models.CharField(db_column='work_place', max_length=50)
#     keywords = models.CharField(db_column='keywords', max_length=20)
#     introduction = models.TextField(db_column='introduction')
#     release_time = models.DateTimeField(verbose_name='发布时间')
#     edit_time = models.DateTimeField(verbose_name='修改时间')
#
#     class Meta:
#         db_table = 'recruitment_info'
#         verbose_name = '招聘信息表'
#
#
# class PositionDetails(models.Model):
#     position_id = models.ForeignKey(RecruitmentInfo, models.CASCADE, verbose_name='职位详情',
#                                     db_column='position_id', related_name='recruitment')
#     responsibilities = models.TextField(db_column='responsibilities', verbose_name='岗位职责')
#     requirements = models.TextField(db_column='requirements', verbose_name='任职要求')
#     welfaretreatment = models.TextField(db_column='welfaretreatment', verbose_name='福利待遇')
#
#     class Meta:
#         db_table = 'positiondetails'
#         verbose_name = '职位详情表'
